using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace DTO
{
    public class SSRFANVInfo
    {
		#region Local Variable
		private String _SUN_DB;
		public String SUN_DB
		{
			get { return _SUN_DB; }
			set { _SUN_DB = value; }
		}
		private String _CATEGORY;
		public String CATEGORY
		{
			get { return _CATEGORY; }
			set { _CATEGORY = value; }
		}
		private String _CODE;
		public String CODE
		{
			get { return _CODE; }
			set { _CODE = value; }
		}
		private String _LOOKUP;
		public String LOOKUP
		{
			get { return _LOOKUP; }
			set { _LOOKUP = value; }
		}
		private String _UPDATED;
		public String UPDATED
		{
			get { return _UPDATED; }
			set { _UPDATED = value; }
		}
		private String _NAME;
		public String NAME
		{
			get { return _NAME; }
			set { _NAME = value; }
		}
		private String _PROHB_POST;
		public String PROHB_POST
		{
			get { return _PROHB_POST; }
			set { _PROHB_POST = value; }
		}
		private String _BUDGET_CHECK;
		public String BUDGET_CHECK
		{
			get { return _BUDGET_CHECK; }
			set { _BUDGET_CHECK = value; }
		}
		private String _BUDGET_STOP;
		public String BUDGET_STOP
		{
			get { return _BUDGET_STOP; }
			set { _BUDGET_STOP = value; }
		}
		private String _DATA_1;
		public String DATA_1
		{
			get { return _DATA_1; }
			set { _DATA_1 = value; }
		}
		private String _NAME2;
		public String NAME2
		{
			get { return _NAME2; }
			set { _NAME2 = value; }
		}
        #endregion LocalVariable
        
        #region Constructor
		public SSRFANVInfo()
		{
			_SUN_DB = "";
			_CATEGORY = "";
			_CODE = "";
			_LOOKUP = "";
			_UPDATED = "";
			_NAME = "";
			_PROHB_POST = "";
			_BUDGET_CHECK = "";
			_BUDGET_STOP = "";
			_DATA_1 = "";
			_NAME2 = "";
		}
		public SSRFANVInfo(
			String SUN_DB,
			String CATEGORY,
			String CODE,
			String LOOKUP,
			String UPDATED,
			String NAME,
			String PROHB_POST,
			String BUDGET_CHECK,
			String BUDGET_STOP,
			String DATA_1,
			String NAME2
			)
		{
			_SUN_DB = SUN_DB;
			_CATEGORY = CATEGORY;
			_CODE = CODE;
			_LOOKUP = LOOKUP;
			_UPDATED = UPDATED;
			_NAME = NAME;
			_PROHB_POST = PROHB_POST;
			_BUDGET_CHECK = BUDGET_CHECK;
			_BUDGET_STOP = BUDGET_STOP;
			_DATA_1 = DATA_1;
			_NAME2 = NAME2;
		}
		public SSRFANVInfo(DataRow dr)
		{
			if (dr != null)
			{
				_SUN_DB = dr["SUN_DB"] == DBNull.Value ? "" : (String)dr["SUN_DB"];
				_CATEGORY = dr["CATEGORY"] == DBNull.Value ? "" : (String)dr["CATEGORY"];
				_CODE = dr["CODE"] == DBNull.Value ? "" : (String)dr["CODE"];
				_LOOKUP = dr["LOOKUP"] == DBNull.Value ? "" : (String)dr["LOOKUP"];
				_UPDATED = dr["UPDATED"] == DBNull.Value ? "" : (String)dr["UPDATED"];
				_NAME = dr["NAME"] == DBNull.Value ? "" : (String)dr["NAME"];
				_PROHB_POST = dr["PROHB_POST"] == DBNull.Value ? "" : (String)dr["PROHB_POST"];
				_BUDGET_CHECK = dr["BUDGET_CHECK"] == DBNull.Value ? "" : (String)dr["BUDGET_CHECK"];
				_BUDGET_STOP = dr["BUDGET_STOP"] == DBNull.Value ? "" : (String)dr["BUDGET_STOP"];
				_DATA_1 = dr["DATA_1"] == DBNull.Value ? "" : (String)dr["DATA_1"];
				_NAME2 = dr["NAME2"] == DBNull.Value ? "" : (String)dr["NAME2"];
			}
		}
        #endregion Constructor
        
        #region InitTable
		public DataTable ToDataTable()
		{
			DataTable dt = new DataTable("TblSSRFANV");
			dt.Columns.AddRange(new DataColumn[] { 
				new DataColumn("SUN_DB", typeof(String)),
				new DataColumn("CATEGORY", typeof(String)),
				new DataColumn("CODE", typeof(String)),
				new DataColumn("LOOKUP", typeof(String)),
				new DataColumn("UPDATED", typeof(String)),
				new DataColumn("NAME", typeof(String)),
				new DataColumn("PROHB_POST", typeof(String)),
				new DataColumn("BUDGET_CHECK", typeof(String)),
				new DataColumn("BUDGET_STOP", typeof(String)),
				new DataColumn("DATA_1", typeof(String)),
				new DataColumn("NAME2", typeof(String))
				});
			return dt;
		}
		public DataRow ToDataRow(DataTable dt)
		{
			DataRow row = dt.NewRow();
			row["SUN_DB"] = _SUN_DB;
			row["CATEGORY"] = _CATEGORY;
			row["CODE"] = _CODE;
			row["LOOKUP"] = _LOOKUP;
			row["UPDATED"] = _UPDATED;
			row["NAME"] = _NAME;
			row["PROHB_POST"] = _PROHB_POST;
			row["BUDGET_CHECK"] = _BUDGET_CHECK;
			row["BUDGET_STOP"] = _BUDGET_STOP;
			row["DATA_1"] = _DATA_1;
			row["NAME2"] = _NAME2;
			return row;
		}
        #endregion InitTable

        public DataTable ToTransferInStruct()
        {
            throw new NotImplementedException();
        }
    }
}
